Performing Column Gap Analysis

A column gap analysis enables you to find:

  • Columns not existing in mappings
  • Source columns existing on mappings without valid target
  • Target columns listed on mappings without business rule and source column

You can perform column gap analysis at:

  • System level: This option enables running the analysis on all the columns under a system.
  • Environment level: This option enables running the analysis on all the columns under an environment.
  • Table level: This option enables running the analysis on all the columns under a table.

To perform column gap analysis at system level, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. Under the Workspace Mappings pane, click a project.
  3. In Metadata Catalogue, right-click a system.

  4. Click Column Gap Analysis.

    5. The Column Gap Analysis page appears.

  5. Select projects and mappings.
  6. Click .

    7. The Column Gap Analysis Report for the selected projects and mappings appears.

To perform column gap analysis at environment level, follow these steps:

  1. In Metadata Catalogue, right-click an environment.

  2. Click Column Gap Analysis.

    3. The Column Gap Analysis page appears.

  3. Select projects and mappings.
  4. Click .

    5. The Column Gap Analysis Report for the selected projects and mappings appears.

To perform column gap analysis at table level, follow these steps:

  1. In Metadata Catalogue, right-click a table.

  2. Click Column Gap Analysis.
  3. The Column Gap Analysis page appears.

    4. Select projects and mappings.

  4. Click .

    5. The Columns Gap Analysis Report for the selected projects and mappings appears.